<!DOCTYPE html>
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<meta name="generator" content="ApiGen 2.8.0" />
	<meta name="robots" content="noindex" />

	<title>File models/users_model.php | tis</title>

	<script type="text/javascript" src="resources/combined.js?955602237"></script>
	<script type="text/javascript" src="elementlist.js?180132949"></script>
	<link rel="stylesheet" type="text/css" media="all" href="resources/style.css?3505392360" />

</head>

<body>
<div id="left">
	<div id="menu">
		<a href="index.html" title="Overview"><span>Overview</span></a>


		<div id="groups">
		</div>



		<div id="elements">
			<h3>Classes</h3>
			<ul>
				<li><a href="class-Auth.html">Auth</a></li>
				<li><a href="class-Books_model.html">Books_model</a></li>
				<li><a href="class-Inout.html">Inout</a></li>
				<li><a href="class-Log_model.html">Log_model</a></li>
				<li><a href="class-Roles_model.html">Roles_model</a></li>
				<li><a href="class-Solution_model.html">Solution_model</a></li>
				<li><a href="class-Tasks.html">Tasks</a></li>
				<li><a href="class-Tasks_model.html">Tasks_model</a></li>
				<li class="active"><a href="class-Users_model.html">Users_model</a></li>
			</ul>





		</div>
	</div>
</div>

<div id="splitter"></div>

<div id="right">
<div id="rightInner">
	<form id="search">
		<input type="hidden" name="cx" value="" />
		<input type="hidden" name="ie" value="UTF-8" />
		<input type="text" name="q" class="text" />
		<input type="submit" value="Search" />
	</form>

	<div id="navigation">
		<ul>
			<li>
				<a href="index.html" title="Overview"><span>Overview</span></a>
			</li>
			<li>
				<a href="class-Users_model.html" title="Summary of Users_model"><span>Class</span></a>
			</li>
		</ul>
		<ul>
			<li>
				<a href="tree.html" title="Tree view of classes, interfaces, traits and exceptions"><span>Tree</span></a>
			</li>
		</ul>
		<ul>
		</ul>
	</div>

<pre><code><span id="1" class="l"><a class="l" href="#1"> 1: </a><span class="xlang">&lt;?php</span>
</span><span id="2" class="l"><a class="l" href="#2"> 2: </a><span class="php-comment">/*
</span></span><span id="3" class="l"><a class="l" href="#3"> 3: </a><span class="php-comment">7.2.2 Users
</span></span><span id="4" class="l"><a class="l" href="#4"> 4: </a><span class="php-comment">Metódy:
</span></span><span id="5" class="l"><a class="l" href="#5"> 5: </a><span class="php-comment">• RegisterUser(polia registračného formulára) – pridá do tabuľky users používateľa.
</span></span><span id="6" class="l"><a class="l" href="#6"> 6: </a><span class="php-comment">• GetUserById($id_user) – vráti používateľa v databáze s primárnym klúčom $userId.
</span></span><span id="7" class="l"><a class="l" href="#7"> 7: </a><span class="php-comment">• GetUserByUsername($username) – vráti používateľa s daným prihlasovacím heslom.
</span></span><span id="8" class="l"><a class="l" href="#8"> 8: </a><span class="php-comment">• DeleteUser($userId) – vymaže daný záznam z tabuľky
</span></span><span id="9" class="l"><a class="l" href="#9"> 9: </a><span class="php-comment">• ListAll($order) – vráti zoznam všetkých záznamov zoradených podľa $order
</span></span><span id="10" class="l"><a class="l" href="#10">10: </a><span class="php-comment">*/</span>
</span><span id="11" class="l"><a class="l" href="#11">11: </a><span class="php-comment">/**
</span></span><span id="12" class="l"><a class="l" href="#12">12: </a><span class="php-comment"> * Trieda Users_model za zaobera prácou s databázou pre užívateľov
</span></span><span id="13" class="l"><a class="l" href="#13">13: </a><span class="php-comment"> * @abstract
</span></span><span id="14" class="l"><a class="l" href="#14">14: </a><span class="php-comment"> * @version    0.01
</span></span><span id="15" class="l"><a class="l" href="#15">15: </a><span class="php-comment"> * @since      2012-29-11
</span></span><span id="16" class="l"><a class="l" href="#16">16: </a><span class="php-comment"> * @author     Este Neviem
</span></span><span id="17" class="l"><a class="l" href="#17">17: </a><span class="php-comment"> */</span>
</span><span id="18" class="l"><a class="l" href="#18">18: </a><span class="php-keyword1">class</span> <a id="Users_model" href="#Users_model">Users_model</a> <span class="php-keyword1">extends</span> CI_Model{
</span><span id="19" class="l"><a class="l" href="#19">19: </a>
</span><span id="20" class="l"><a class="l" href="#20">20: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="___construct" href="#___construct">__construct</a>(){
</span><span id="21" class="l"><a class="l" href="#21">21: </a>        <span class="php-var">$this</span>-&gt;load-&gt;database();
</span><span id="22" class="l"><a class="l" href="#22">22: </a>    }
</span><span id="23" class="l"><a class="l" href="#23">23: </a>
</span><span id="24" class="l"><a class="l" href="#24">24: </a>    <span class="php-comment">// zaregistruje pouzivatela</span>
</span><span id="25" class="l"><a class="l" href="#25">25: </a>    <span class="php-comment">/**
</span></span><span id="26" class="l"><a class="l" href="#26">26: </a><span class="php-comment">     * funkcia pridá do tabuľky users používateľa podľa parametrov.
</span></span><span id="27" class="l"><a class="l" href="#27">27: </a><span class="php-comment">     * @param type $username
</span></span><span id="28" class="l"><a class="l" href="#28">28: </a><span class="php-comment">     * @param type $pass
</span></span><span id="29" class="l"><a class="l" href="#29">29: </a><span class="php-comment">     * @param type $firstname
</span></span><span id="30" class="l"><a class="l" href="#30">30: </a><span class="php-comment">     * @param type $lastname
</span></span><span id="31" class="l"><a class="l" href="#31">31: </a><span class="php-comment">     * @param type $year
</span></span><span id="32" class="l"><a class="l" href="#32">32: </a><span class="php-comment">     * @version    0.01
</span></span><span id="33" class="l"><a class="l" href="#33">33: </a><span class="php-comment">     * @since      2012-28-11
</span></span><span id="34" class="l"><a class="l" href="#34">34: </a><span class="php-comment">     * @author     Este Neviem
</span></span><span id="35" class="l"><a class="l" href="#35">35: </a><span class="php-comment">     */</span>
</span><span id="36" class="l"><a class="l" href="#36">36: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_registerUser" href="#_registerUser">registerUser</a>(<span class="php-var">$username</span>, <span class="php-var">$pass</span>, <span class="php-var">$firstname</span>, <span class="php-var">$lastname</span>, <span class="php-var">$year</span>){
</span><span id="37" class="l"><a class="l" href="#37">37: </a>        <span class="php-var">$this</span>-&gt;db-&gt;insert(<span class="php-quote">'users'</span>, <span class="php-keyword1">array</span>(
</span><span id="38" class="l"><a class="l" href="#38">38: </a>            <span class="php-quote">'fk_roles'</span> =&gt; <span class="php-num">1</span>, <span class="php-comment">// student</span>
</span><span id="39" class="l"><a class="l" href="#39">39: </a>            <span class="php-quote">'email'</span> =&gt; <span class="php-var">$username</span>,
</span><span id="40" class="l"><a class="l" href="#40">40: </a>            <span class="php-quote">'password'</span> =&gt; <span class="php-var">$pass</span>,
</span><span id="41" class="l"><a class="l" href="#41">41: </a>            <span class="php-quote">'firstname'</span> =&gt;<span class="php-var">$firstname</span>,
</span><span id="42" class="l"><a class="l" href="#42">42: </a>            <span class="php-quote">'lastname'</span> =&gt; <span class="php-var">$lastname</span>,
</span><span id="43" class="l"><a class="l" href="#43">43: </a>            <span class="php-quote">'year'</span> =&gt; <span class="php-var">$year</span>
</span><span id="44" class="l"><a class="l" href="#44">44: </a>        ));
</span><span id="45" class="l"><a class="l" href="#45">45: </a>    }
</span><span id="46" class="l"><a class="l" href="#46">46: </a>
</span><span id="47" class="l"><a class="l" href="#47">47: </a>    <span class="php-comment">/**
</span></span><span id="48" class="l"><a class="l" href="#48">48: </a><span class="php-comment">     * Funkcai vráti používateľa v databáze s primárnym klúčom $userId.
</span></span><span id="49" class="l"><a class="l" href="#49">49: </a><span class="php-comment">     * @param type $id_user
</span></span><span id="50" class="l"><a class="l" href="#50">50: </a><span class="php-comment">     * @version    0.01
</span></span><span id="51" class="l"><a class="l" href="#51">51: </a><span class="php-comment">     * @since      2012-28-11
</span></span><span id="52" class="l"><a class="l" href="#52">52: </a><span class="php-comment">     * @author     Este Neviem
</span></span><span id="53" class="l"><a class="l" href="#53">53: </a><span class="php-comment">     */</span>
</span><span id="54" class="l"><a class="l" href="#54">54: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getUserById" href="#_getUserById">getUserById</a>(<span class="php-var">$id_user</span>){
</span><span id="55" class="l"><a class="l" href="#55">55: </a>        <span class="php-var">$this</span>-&gt;db-&gt;from(<span class="php-quote">'users'</span>)-&gt;where(<span class="php-quote">'id'</span>,<span class="php-var">$id_user</span>);
</span><span id="56" class="l"><a class="l" href="#56">56: </a>         <span class="php-var">$query</span> = <span class="php-var">$this</span>-&gt;db-&gt;get(); 
</span><span id="57" class="l"><a class="l" href="#57">57: </a>         <span class="php-var">$res</span> = <span class="php-var">$query</span>-&gt;result();
</span><span id="58" class="l"><a class="l" href="#58">58: </a>         <span class="php-keyword1">return</span> <span class="php-var">$res</span>[<span class="php-num">0</span>];
</span><span id="59" class="l"><a class="l" href="#59">59: </a>    }
</span><span id="60" class="l"><a class="l" href="#60">60: </a>
</span><span id="61" class="l"><a class="l" href="#61">61: </a>    <span class="php-comment">/**
</span></span><span id="62" class="l"><a class="l" href="#62">62: </a><span class="php-comment">     * Funkcia vráti používateľa s daným prihlasovacím heslom.
</span></span><span id="63" class="l"><a class="l" href="#63">63: </a><span class="php-comment">     * @param type $username
</span></span><span id="64" class="l"><a class="l" href="#64">64: </a><span class="php-comment">     * @version    0.01
</span></span><span id="65" class="l"><a class="l" href="#65">65: </a><span class="php-comment">     * @since      2012-28-11
</span></span><span id="66" class="l"><a class="l" href="#66">66: </a><span class="php-comment">     * @author     Este Neviem
</span></span><span id="67" class="l"><a class="l" href="#67">67: </a><span class="php-comment">     */</span>
</span><span id="68" class="l"><a class="l" href="#68">68: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_getUserByUsername" href="#_getUserByUsername">getUserByUsername</a>(<span class="php-var">$username</span>){
</span><span id="69" class="l"><a class="l" href="#69">69: </a>        <span class="php-var">$this</span>-&gt;db-&gt;from(<span class="php-quote">'users'</span>)-&gt;where(<span class="php-quote">'email'</span>,<span class="php-var">$username</span>);
</span><span id="70" class="l"><a class="l" href="#70">70: </a>         <span class="php-var">$query</span> = <span class="php-var">$this</span>-&gt;db-&gt;get(); 
</span><span id="71" class="l"><a class="l" href="#71">71: </a>         <span class="php-var">$res</span> = <span class="php-var">$query</span>-&gt;result();
</span><span id="72" class="l"><a class="l" href="#72">72: </a>         <span class="php-keyword1">return</span> <span class="php-var">$res</span>[<span class="php-num">0</span>];
</span><span id="73" class="l"><a class="l" href="#73">73: </a>    }
</span><span id="74" class="l"><a class="l" href="#74">74: </a>
</span><span id="75" class="l"><a class="l" href="#75">75: </a>    <span class="php-comment">/**
</span></span><span id="76" class="l"><a class="l" href="#76">76: </a><span class="php-comment">     * Funkcia vymaže daný záznam z tabuľky podľa parametra
</span></span><span id="77" class="l"><a class="l" href="#77">77: </a><span class="php-comment">     * @param type $id_user
</span></span><span id="78" class="l"><a class="l" href="#78">78: </a><span class="php-comment">     * @version    0.01
</span></span><span id="79" class="l"><a class="l" href="#79">79: </a><span class="php-comment">     * @since      2012-28-11
</span></span><span id="80" class="l"><a class="l" href="#80">80: </a><span class="php-comment">     * @author     Este Neviem
</span></span><span id="81" class="l"><a class="l" href="#81">81: </a><span class="php-comment">     */</span>
</span><span id="82" class="l"><a class="l" href="#82">82: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_deleteUser" href="#_deleteUser">deleteUser</a>(<span class="php-var">$id_user</span>){
</span><span id="83" class="l"><a class="l" href="#83">83: </a>           <span class="php-var">$this</span>-&gt;db-&gt;<span class="php-keyword2">delete</span>(<span class="php-quote">'users'</span>, <span class="php-keyword1">array</span>(<span class="php-quote">'id'</span> =&gt; <span class="php-var">$id_user</span>));
</span><span id="84" class="l"><a class="l" href="#84">84: </a>    }
</span><span id="85" class="l"><a class="l" href="#85">85: </a>
</span><span id="86" class="l"><a class="l" href="#86">86: </a>    <span class="php-comment">/**
</span></span><span id="87" class="l"><a class="l" href="#87">87: </a><span class="php-comment">     * Funkcia vráti zoznam všetkých záznamov zoradených podľa parametra $order
</span></span><span id="88" class="l"><a class="l" href="#88">88: </a><span class="php-comment">     * @param type $order
</span></span><span id="89" class="l"><a class="l" href="#89">89: </a><span class="php-comment">     * @version    0.01
</span></span><span id="90" class="l"><a class="l" href="#90">90: </a><span class="php-comment">     * @since      2012-28-11
</span></span><span id="91" class="l"><a class="l" href="#91">91: </a><span class="php-comment">     * @author     Este Neviem
</span></span><span id="92" class="l"><a class="l" href="#92">92: </a><span class="php-comment">     */</span>
</span><span id="93" class="l"><a class="l" href="#93">93: </a>    <span class="php-keyword1">public</span> <span class="php-keyword1">function</span> <a id="_listAll" href="#_listAll">listAll</a>(<span class="php-var">$order</span>){
</span><span id="94" class="l"><a class="l" href="#94">94: </a>          <span class="php-keyword1">return</span> <span class="php-var">$this</span>-&gt;db-&gt;query(<span class="php-quote">'SELECT * FROM users ORDER BY '</span>.<span class="php-var">$order</span>)-&gt;result();
</span><span id="95" class="l"><a class="l" href="#95">95: </a>    }
</span><span id="96" class="l"><a class="l" href="#96">96: </a>
</span><span id="97" class="l"><a class="l" href="#97">97: </a>}
</span><span id="98" class="l"><a class="l" href="#98">98: </a>
</span><span id="99" class="l"><a class="l" href="#99">99: </a></span><span class="xlang">?&gt;</span></code></pre>

	<div id="footer">
		tis API documentation generated by <a href="http://apigen.org">ApiGen 2.8.0</a>
	</div>
</div>
</div>
</body>
</html>
